<%@ Page Language="VB" AutoEventWireup="false" CodeFile="TestPivotTableWrapper.aspx.vb" Inherits="TestPivotTableWrapper" %>

<%@ Register Assembly="OWCNetWrapper" Namespace="Rajware.Office.WebControls" TagPrefix="cc1" %>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        <cc1:pivottablewrapper 
            id="PivotTableWrapper1" 
            runat="server" 
            AutoFit="false"
        >&lt;xml xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;
 &lt;x:PivotTable&gt;
  &lt;x:OWCVersion&gt;11.0.0.8166         &lt;/x:OWCVersion&gt;
  &lt;x:DisplayScreenTips/&gt;
  &lt;x:CubeProvider&gt;msolap.2&lt;/x:CubeProvider&gt;
  &lt;x:DisplayFieldList/&gt;
  &lt;x:FieldListTop&gt;48&lt;/x:FieldListTop&gt;
  &lt;x:FieldListLeft&gt;569&lt;/x:FieldListLeft&gt;
  &lt;x:FieldListBottom&gt;417&lt;/x:FieldListBottom&gt;
  &lt;x:FieldListRight&gt;769&lt;/x:FieldListRight&gt;
  &lt;x:CacheDetails/&gt;
  &lt;x:ConnectionString&gt;Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=RACSampleDB;Data Source=ALEXSERVER&lt;/x:ConnectionString&gt;
  &lt;x:DataMember&gt;dbo.SampleTable&lt;/x:DataMember&gt;
  &lt;x:Name&gt;Microsoft Office PivotTable 11.0&lt;/x:Name&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Id&lt;/x:Name&gt;
   &lt;x:DataType&gt;Integer&lt;/x:DataType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Date&lt;/x:Name&gt;
   &lt;x:DataType&gt;Date&lt;/x:DataType&gt;
   &lt;x:ParentField&gt;Years&lt;/x:ParentField&gt;
   &lt;x:GroupType&gt;Seconds&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Seconds&lt;/x:PLCaption&gt;
   &lt;x:FilterCaption&gt;Date By Week&lt;/x:FilterCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;ss&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Cat&lt;/x:Name&gt;
   &lt;x:DataType&gt;Integer&lt;/x:DataType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Dog&lt;/x:Name&gt;
   &lt;x:DataType&gt;Integer&lt;/x:DataType&gt;
   &lt;x:PLDataOrientation/&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Cow&lt;/x:Name&gt;
   &lt;x:DataType&gt;Integer&lt;/x:DataType&gt;
   &lt;x:PLDataOrientation/&gt;
   &lt;x:PLPosition&gt;2&lt;/x:PLPosition&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Org&lt;/x:Name&gt;
   &lt;x:EncodedType&gt;adVarChar&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Minutes&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Minutes&lt;/x:GroupType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;mm:&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Hours&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Hours&lt;/x:GroupType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;hh&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Days&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Days&lt;/x:GroupType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;dddd&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Months&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Months&lt;/x:GroupType&gt;
   &lt;x:PLGroupType&gt;Weeks&lt;/x:PLGroupType&gt;
   &lt;x:PLCaption&gt;Weeks&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Years&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Years&lt;/x:GroupType&gt;
   &lt;x:Orientation&gt;Row&lt;/x:Orientation&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;yyyy&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
   &lt;x:Expanded/&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PivotField&gt;
   &lt;x:Name&gt;Data&lt;/x:Name&gt;
   &lt;x:Orientation&gt;Column&lt;/x:Orientation&gt;
   &lt;x:Position&gt;-1&lt;/x:Position&gt;
   &lt;x:DataField/&gt;
  &lt;/x:PivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Date1&lt;/x:Name&gt;
   &lt;x:SourceName&gt;Date&lt;/x:SourceName&gt;
   &lt;x:DataType&gt;Date&lt;/x:DataType&gt;
   &lt;x:PLCaption&gt;Date&lt;/x:PLCaption&gt;
   &lt;x:FilterCaption&gt;Date&lt;/x:FilterCaption&gt;
   &lt;x:EncodedType&gt;adDBTimeStamp&lt;/x:EncodedType&gt;
   &lt;x:CompareOrderedMembersBy&gt;UniqueName&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Date By Week&lt;/x:Name&gt;
   &lt;x:SourceName&gt;Date&lt;/x:SourceName&gt;
   &lt;x:BoundField/&gt;
   &lt;x:AutoDateType&gt;ByWeek&lt;/x:AutoDateType&gt;
   &lt;x:DataType&gt;Date&lt;/x:DataType&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Date By Month&lt;/x:Name&gt;
   &lt;x:SourceName&gt;Date&lt;/x:SourceName&gt;
   &lt;x:BoundField/&gt;
   &lt;x:AutoDateType&gt;ByMonth&lt;/x:AutoDateType&gt;
   &lt;x:DataType&gt;Date&lt;/x:DataType&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Date2&lt;/x:Name&gt;
   &lt;x:SourceName&gt;Date&lt;/x:SourceName&gt;
   &lt;x:DataType&gt;Date&lt;/x:DataType&gt;
   &lt;x:ParentField&gt;Years1&lt;/x:ParentField&gt;
   &lt;x:GroupType&gt;Seconds&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Seconds&lt;/x:PLCaption&gt;
   &lt;x:FilterCaption&gt;Date By Month&lt;/x:FilterCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;ss&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Minutes1&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Minutes&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Minutes&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;mm:&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Hours1&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Hours&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Hours&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;hh&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Days1&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Days&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Days&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;dd-mmm&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Months1&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Months&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Months&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;mmm&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Quarters&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Quarters&lt;/x:GroupType&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;&amp;quot;Qtr&amp;quot;#&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PLPivotField&gt;
   &lt;x:Name&gt;Years1&lt;/x:Name&gt;
   &lt;x:BaseField&gt;Date2&lt;/x:BaseField&gt;
   &lt;x:GroupType&gt;Years&lt;/x:GroupType&gt;
   &lt;x:PLCaption&gt;Years&lt;/x:PLCaption&gt;
   &lt;x:EncodedType&gt;adInteger&lt;/x:EncodedType&gt;
   &lt;x:NumberFormat&gt;yyyy&lt;/x:NumberFormat&gt;
   &lt;x:CompareOrderedMembersBy&gt;Name&lt;/x:CompareOrderedMembersBy&gt;
  &lt;/x:PLPivotField&gt;
  &lt;x:PivotData&gt;
   &lt;x:Top&gt;0.0&lt;/x:Top&gt;
   &lt;x:TopOffset&gt;0&lt;/x:TopOffset&gt;
   &lt;x:Left&gt;0&lt;/x:Left&gt;
   &lt;x:LeftOffset&gt;0&lt;/x:LeftOffset&gt;
   &lt;x:SeqNum&gt;7&lt;/x:SeqNum&gt;
   &lt;x:Expanded/&gt;
  &lt;/x:PivotData&gt;
  &lt;x:PivotView&gt;
   &lt;x:IsNotFiltered/&gt;
  &lt;/x:PivotView&gt;
 &lt;/x:PivotTable&gt;
&lt;/xml&gt;</cc1:pivottablewrapper>

    </div>
    </form>
</body>
</html>
